Overview
Brought to you by YData
Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 913595 |
| Missing cells | 1465 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 175.1 MiB |
| Average record size in memory | 201.0 B |
Variable types
| Numeric | 14 |
|---|---|
| DateTime | 3 |
| Categorical | 3 |
breadth is highly overall correlated with draught and 1 other fields | High correlation |
course_over_ground is highly overall correlated with true_heading | High correlation |
destination is highly overall correlated with end_latitude and 4 other fields | High correlation |
draught is highly overall correlated with breadth and 1 other fields | High correlation |
end_latitude is highly overall correlated with destination and 7 other fields | High correlation |
end_longitude is highly overall correlated with destination and 7 other fields | High correlation |
end_port is highly overall correlated with destination and 7 other fields | High correlation |
latitude is highly overall correlated with end_latitude and 6 other fields | High correlation |
length is highly overall correlated with breadth and 1 other fields | High correlation |
longitude is highly overall correlated with end_latitude and 6 other fields | High correlation |
start_latitude is highly overall correlated with end_latitude and 6 other fields | High correlation |
start_longitude is highly overall correlated with destination and 7 other fields | High correlation |
start_port is highly overall correlated with destination and 7 other fields | High correlation |
true_heading is highly overall correlated with course_over_ground | High correlation |
destination is highly imbalanced (55.3%) | Imbalance |
Reproduction
| Analysis started | 2025-06-10 22:05:04.508589 |
|---|---|
| Analysis finished | 2025-06-10 22:05:56.347438 |
| Duration | 51.84 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
trip_id
Real number (ℝ)
| Distinct | 1126 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1125611.9 |
| Minimum | 5944 |
|---|---|
| Maximum | 2278147 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 5944 |
|---|---|
| 5-th percentile | 55365 |
| Q1 | 473272 |
| median | 1170717 |
| Q3 | 1669988 |
| 95-th percentile | 2160044 |
| Maximum | 2278147 |
| Range | 2272203 |
| Interquartile range (IQR) | 1196716 |
Descriptive statistics
| Standard deviation | 673814.36 |
|---|---|
| Coefficient of variation (CV) | 0.59862048 |
| Kurtosis | -1.2739622 |
| Mean | 1125611.9 |
| Median Absolute Deviation (MAD) | 546619 |
| Skewness | -0.039517174 |
| Sum | 1.0283534 × 1012 |
| Variance | 4.5402579 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2183472 | 2609 | 0.3% |
| 1669988 | 2362 | 0.3% |
| 265994 | 2085 | 0.2% |
| 1778056 | 2068 | 0.2% |
| 2201111 | 2059 | 0.2% |
| 1993462 | 2053 | 0.2% |
| 1019076 | 2036 | 0.2% |
| 2183480 | 2026 | 0.2% |
| 624032 | 1994 | 0.2% |
| 1677413 | 1989 | 0.2% |
| Other values (1116) | 892314 |
| Value | Count | Frequency (%) |
| 5944 | 1237 | |
| 10257 | 577 | 0.1% |
| 19002 | 41 | < 0.1% |
| 19585 | 1646 | |
| 23834 | 1241 | |
| 24805 | 595 | 0.1% |
| 25124 | 659 | |
| 28257 | 1280 | |
| 29139 | 1247 | |
| 29152 | 1296 |
| Value | Count | Frequency (%) |
| 2278147 | 518 | |
| 2278140 | 588 | |
| 2278125 | 528 | |
| 2278114 | 574 | |
| 2278113 | 574 | |
| 2278085 | 522 | |
| 2278084 | 522 | |
| 2278083 | 522 | |
| 2278070 | 494 | |
| 2278069 | 494 |
start_latitude
Real number (ℝ)
High correlation 
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.033007 |
| Minimum | 53.33 |
|---|---|
| Maximum | 54.54 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 53.33 |
|---|---|
| 5-th percentile | 53.52 |
| Q1 | 53.58 |
| median | 54.36 |
| Q3 | 54.36 |
| 95-th percentile | 54.36 |
| Maximum | 54.54 |
| Range | 1.21 |
| Interquartile range (IQR) | 0.78 |
Descriptive statistics
| Standard deviation | 0.39140852 |
|---|---|
| Coefficient of variation (CV) | 0.0072438781 |
| Kurtosis | -1.8378472 |
| Mean | 54.033007 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.3615352 |
| Sum | 49364285 |
| Variance | 0.15320063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 54.36 | 525478 | |
| 53.58 | 168718 | 18.5% |
| 53.59 | 56719 | 6.2% |
| 53.51 | 34008 | 3.7% |
| 53.57 | 26593 | 2.9% |
| 53.53 | 23437 | 2.6% |
| 53.6 | 21983 | 2.4% |
| 53.52 | 10380 | 1.1% |
| 53.55 | 5686 | 0.6% |
| 53.56 | 5650 | 0.6% |
| Other values (18) | 34943 | 3.8% |
| Value | Count | Frequency (%) |
| 53.33 | 3169 | 0.3% |
| 53.34 | 2535 | 0.3% |
| 53.5 | 1285 | 0.1% |
| 53.51 | 34008 | |
| 53.52 | 10380 | 1.1% |
| 53.53 | 23437 | |
| 53.54 | 1288 | 0.1% |
| 53.55 | 5686 | 0.6% |
| 53.56 | 5650 | 0.6% |
| 53.57 | 26593 |
| Value | Count | Frequency (%) |
| 54.54 | 3667 | 0.4% |
| 54.49 | 552 | 0.1% |
| 54.37 | 1257 | 0.1% |
| 54.36 | 525478 | |
| 54.33 | 3161 | 0.3% |
| 54.31 | 1158 | 0.1% |
| 53.75 | 976 | 0.1% |
| 53.74 | 530 | 0.1% |
| 53.67 | 2150 | 0.2% |
| 53.66 | 411 | < 0.1% |
start_longitude
Real number (ℝ)
High correlation 
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.4652193 |
| Minimum | 8.14 |
|---|---|
| Maximum | 10.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 8.14 |
|---|---|
| 5-th percentile | 8.5 |
| Q1 | 8.52 |
| median | 10.14 |
| Q3 | 10.14 |
| 95-th percentile | 10.14 |
| Maximum | 10.34 |
| Range | 2.2 |
| Interquartile range (IQR) | 1.62 |
Descriptive statistics
| Standard deviation | 0.80564026 |
|---|---|
| Coefficient of variation (CV) | 0.085115858 |
| Kurtosis | -1.8490887 |
| Mean | 9.4652193 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.36017706 |
| Sum | 8647377 |
| Variance | 0.64905624 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.14 | 498283 | |
| 8.52 | 160444 | 17.6% |
| 8.53 | 78601 | 8.6% |
| 8.51 | 36432 | 4.0% |
| 8.57 | 31343 | 3.4% |
| 10.13 | 24011 | 2.6% |
| 8.54 | 15226 | 1.7% |
| 8.5 | 11982 | 1.3% |
| 8.15 | 10964 | 1.2% |
| 8.49 | 9062 | 1.0% |
| Other values (24) | 37247 | 4.1% |
| Value | Count | Frequency (%) |
| 8.14 | 485 | 0.1% |
| 8.15 | 10964 | |
| 8.16 | 1297 | 0.1% |
| 8.19 | 976 | 0.1% |
| 8.22 | 530 | 0.1% |
| 8.36 | 1078 | 0.1% |
| 8.37 | 1072 | 0.1% |
| 8.38 | 411 | < 0.1% |
| 8.39 | 984 | 0.1% |
| 8.4 | 523 | 0.1% |
| Value | Count | Frequency (%) |
| 10.34 | 552 | 0.1% |
| 10.29 | 3667 | 0.4% |
| 10.18 | 3188 | 0.3% |
| 10.17 | 2933 | 0.3% |
| 10.16 | 1485 | 0.2% |
| 10.15 | 1154 | 0.1% |
| 10.14 | 498283 | |
| 10.13 | 24011 | 2.6% |
| 8.57 | 31343 | 3.4% |
| 8.56 | 3146 | 0.3% |
start_time
Date
| Distinct | 953 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| Minimum | 2016-01-13 06:03:00+00:00 |
|---|---|
| Maximum | 2017-05-26 19:44:00+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
end_latitude
Real number (ℝ)
High correlation 
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.084077 |
| Minimum | 53.47 |
|---|---|
| Maximum | 54.64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 53.47 |
|---|---|
| 5-th percentile | 53.5 |
| Q1 | 53.53 |
| median | 54.38 |
| Q3 | 54.53 |
| 95-th percentile | 54.54 |
| Maximum | 54.64 |
| Range | 1.17 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.47536535 |
|---|---|
| Coefficient of variation (CV) | 0.0087893772 |
| Kurtosis | -1.8529172 |
| Mean | 54.084077 |
| Median Absolute Deviation (MAD) | 0.16 |
| Skewness | -0.31327499 |
| Sum | 49410942 |
| Variance | 0.22597222 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 54.54 | 217507 | |
| 53.53 | 194398 | |
| 53.5 | 87533 | |
| 54.38 | 85200 | 9.3% |
| 54.52 | 54379 | 6.0% |
| 54.53 | 40516 | 4.4% |
| 53.54 | 37790 | 4.1% |
| 54.44 | 33365 | 3.7% |
| 53.52 | 31820 | 3.5% |
| 54.43 | 24028 | 2.6% |
| Other values (19) | 107059 |
| Value | Count | Frequency (%) |
| 53.47 | 1290 | 0.1% |
| 53.48 | 677 | 0.1% |
| 53.49 | 9439 | 1.0% |
| 53.5 | 87533 | |
| 53.51 | 10829 | 1.2% |
| 53.52 | 31820 | 3.5% |
| 53.53 | 194398 | |
| 53.54 | 37790 | 4.1% |
| 53.56 | 678 | 0.1% |
| 53.61 | 2018 | 0.2% |
| Value | Count | Frequency (%) |
| 54.64 | 1646 | 0.2% |
| 54.59 | 740 | 0.1% |
| 54.54 | 217507 | |
| 54.53 | 40516 | 4.4% |
| 54.52 | 54379 | 6.0% |
| 54.51 | 5163 | 0.6% |
| 54.5 | 522 | 0.1% |
| 54.47 | 1280 | 0.1% |
| 54.46 | 7687 | 0.8% |
| 54.45 | 8797 | 1.0% |
end_longitude
Real number (ℝ)
High correlation 
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.995004 |
| Minimum | 9.5 |
|---|---|
| Maximum | 18.92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 9.5 |
|---|---|
| 5-th percentile | 9.9 |
| Q1 | 9.93 |
| median | 18.5 |
| Q3 | 18.6 |
| 95-th percentile | 18.71 |
| Maximum | 18.92 |
| Range | 9.42 |
| Interquartile range (IQR) | 8.67 |
Descriptive statistics
| Standard deviation | 4.2753309 |
|---|---|
| Coefficient of variation (CV) | 0.28511702 |
| Kurtosis | -1.8773597 |
| Mean | 14.995004 |
| Median Absolute Deviation (MAD) | 0.17 |
| Skewness | -0.34812911 |
| Sum | 13699361 |
| Variance | 18.278454 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18.51 | 115647 | |
| 18.5 | 101860 | 11.1% |
| 9.91 | 100740 | 11.0% |
| 9.93 | 76722 | 8.4% |
| 9.9 | 60305 | 6.6% |
| 18.65 | 45248 | 5.0% |
| 9.95 | 44441 | 4.9% |
| 18.66 | 44309 | 4.8% |
| 18.67 | 37754 | 4.1% |
| 9.82 | 27616 | 3.0% |
| Other values (37) | 258953 |
| Value | Count | Frequency (%) |
| 9.5 | 1189 | 0.1% |
| 9.51 | 661 | 0.1% |
| 9.54 | 1196 | 0.1% |
| 9.55 | 178 | < 0.1% |
| 9.56 | 644 | 0.1% |
| 9.73 | 678 | 0.1% |
| 9.82 | 27616 | |
| 9.83 | 6963 | 0.8% |
| 9.88 | 1221 | 0.1% |
| 9.9 | 60305 |
| Value | Count | Frequency (%) |
| 18.92 | 1646 | 0.2% |
| 18.88 | 740 | 0.1% |
| 18.83 | 7385 | 0.8% |
| 18.82 | 11996 | |
| 18.81 | 4884 | 0.5% |
| 18.75 | 1500 | 0.2% |
| 18.72 | 3774 | 0.4% |
| 18.71 | 27107 | |
| 18.7 | 7897 | 0.9% |
| 18.68 | 3368 | 0.4% |
end_time
Date
| Distinct | 943 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| Minimum | 2016-01-13 14:36:00+00:00 |
|---|---|
| Maximum | 2017-05-27 22:11:00+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
start_port
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 892.5 KiB |
| KIEL | |
|---|---|
| BREMERHAVEN |
Length
| Max length | 11 |
|---|---|
| Median length | 4 |
| Mean length | 6.8987177 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BREMERHAVEN |
|---|---|
| 2nd row | BREMERHAVEN |
| 3rd row | BREMERHAVEN |
| 4th row | BREMERHAVEN |
| 5th row | BREMERHAVEN |
Common Values
| Value | Count | Frequency (%) |
| KIEL | 535273 | |
| BREMERHAVEN | 378322 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| kiel | 535273 | |
| bremerhaven | 378322 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 1670239 | |
| R | 756644 | |
| K | 535273 | 8.5% |
| I | 535273 | 8.5% |
| L | 535273 | 8.5% |
| B | 378322 | 6.0% |
| M | 378322 | 6.0% |
| H | 378322 | 6.0% |
| A | 378322 | 6.0% |
| V | 378322 | 6.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6302634 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 1670239 | |
| R | 756644 | |
| K | 535273 | 8.5% |
| I | 535273 | 8.5% |
| L | 535273 | 8.5% |
| B | 378322 | 6.0% |
| M | 378322 | 6.0% |
| H | 378322 | 6.0% |
| A | 378322 | 6.0% |
| V | 378322 | 6.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6302634 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 1670239 | |
| R | 756644 | |
| K | 535273 | 8.5% |
| I | 535273 | 8.5% |
| L | 535273 | 8.5% |
| B | 378322 | 6.0% |
| M | 378322 | 6.0% |
| H | 378322 | 6.0% |
| A | 378322 | 6.0% |
| V | 378322 | 6.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6302634 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 1670239 | |
| R | 756644 | |
| K | 535273 | 8.5% |
| I | 535273 | 8.5% |
| L | 535273 | 8.5% |
| B | 378322 | 6.0% |
| M | 378322 | 6.0% |
| H | 378322 | 6.0% |
| A | 378322 | 6.0% |
| V | 378322 | 6.0% |
end_port
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 892.5 KiB |
| GDYNIA | |
|---|---|
| HAMBURG |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.4141025 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HAMBURG |
|---|---|
| 2nd row | HAMBURG |
| 3rd row | HAMBURG |
| 4th row | HAMBURG |
| 5th row | HAMBURG |
Common Values
| Value | Count | Frequency (%) |
| GDYNIA | 535273 | |
| HAMBURG | 378322 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| gdynia | 535273 | |
| hamburg | 378322 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 913595 | |
| A | 913595 | |
| D | 535273 | |
| Y | 535273 | |
| N | 535273 | |
| I | 535273 | |
| H | 378322 | |
| M | 378322 | |
| B | 378322 | |
| U | 378322 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5859892 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 913595 | |
| A | 913595 | |
| D | 535273 | |
| Y | 535273 | |
| N | 535273 | |
| I | 535273 | |
| H | 378322 | |
| M | 378322 | |
| B | 378322 | |
| U | 378322 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5859892 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 913595 | |
| A | 913595 | |
| D | 535273 | |
| Y | 535273 | |
| N | 535273 | |
| I | 535273 | |
| H | 378322 | |
| M | 378322 | |
| B | 378322 | |
| U | 378322 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5859892 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 913595 | |
| A | 913595 | |
| D | 535273 | |
| Y | 535273 | |
| N | 535273 | |
| I | 535273 | |
| H | 378322 | |
| M | 378322 | |
| B | 378322 | |
| U | 378322 |
time_stamp
Date
| Distinct | 414192 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| Minimum | 2016-01-13 06:03:00+00:00 |
|---|---|
| Maximum | 2017-05-27 22:11:00+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
ship_type
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1397 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.273954 |
| Minimum | 69 |
|---|---|
| Maximum | 89 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 69 |
|---|---|
| 5-th percentile | 70 |
| Q1 | 70 |
| median | 71 |
| Q3 | 71 |
| 95-th percentile | 80 |
| Maximum | 89 |
| Range | 20 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.5283781 |
|---|---|
| Coefficient of variation (CV) | 0.048819498 |
| Kurtosis | 0.87815848 |
| Mean | 72.273954 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.5950954 |
| Sum | 65928156 |
| Variance | 12.449452 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 71 | 409205 | |
| 70 | 311891 | |
| 79 | 123826 | 13.6% |
| 81 | 34540 | 3.8% |
| 72 | 12889 | 1.4% |
| 80 | 11035 | 1.2% |
| 73 | 3629 | 0.4% |
| 74 | 3441 | 0.4% |
| 69 | 1158 | 0.1% |
| 89 | 584 | 0.1% |
| (Missing) | 1397 | 0.2% |
| Value | Count | Frequency (%) |
| 69 | 1158 | 0.1% |
| 70 | 311891 | |
| 71 | 409205 | |
| 72 | 12889 | 1.4% |
| 73 | 3629 | 0.4% |
| 74 | 3441 | 0.4% |
| 79 | 123826 | 13.6% |
| 80 | 11035 | 1.2% |
| 81 | 34540 | 3.8% |
| 89 | 584 | 0.1% |
| Value | Count | Frequency (%) |
| 89 | 584 | 0.1% |
| 81 | 34540 | 3.8% |
| 80 | 11035 | 1.2% |
| 79 | 123826 | 13.6% |
| 74 | 3441 | 0.4% |
| 73 | 3629 | 0.4% |
| 72 | 12889 | 1.4% |
| 71 | 409205 | |
| 70 | 311891 | |
| 69 | 1158 | 0.1% |
length
Real number (ℝ)
High correlation 
| Distinct | 98 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 128.58654 |
| Minimum | 45 |
|---|---|
| Maximum | 399 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 45 |
|---|---|
| 5-th percentile | 74 |
| Q1 | 89 |
| median | 134 |
| Q3 | 154 |
| 95-th percentile | 171 |
| Maximum | 399 |
| Range | 354 |
| Interquartile range (IQR) | 65 |
Descriptive statistics
| Standard deviation | 42.463217 |
|---|---|
| Coefficient of variation (CV) | 0.33023064 |
| Kurtosis | 6.8184036 |
| Mean | 128.58654 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 1.4993322 |
| Sum | 1.1747602 × 108 |
| Variance | 1803.1248 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 151 | 89298 | 9.8% |
| 134 | 77596 | 8.5% |
| 88 | 61305 | 6.7% |
| 155 | 58877 | 6.4% |
| 125 | 47108 | 5.2% |
| 168 | 40709 | 4.5% |
| 82 | 34548 | 3.8% |
| 79 | 34121 | 3.7% |
| 154 | 32709 | 3.6% |
| 68 | 31700 | 3.5% |
| Other values (88) | 405624 |
| Value | Count | Frequency (%) |
| 45 | 1771 | 0.2% |
| 65 | 1648 | 0.2% |
| 66 | 1522 | 0.2% |
| 68 | 31700 | |
| 70 | 5482 | 0.6% |
| 74 | 9892 | 1.1% |
| 75 | 10113 | 1.1% |
| 79 | 34121 | |
| 80 | 1617 | 0.2% |
| 81 | 8660 | 0.9% |
| Value | Count | Frequency (%) |
| 399 | 1716 | |
| 397 | 1153 | 0.1% |
| 396 | 660 | 0.1% |
| 300 | 1142 | 0.1% |
| 299 | 537 | 0.1% |
| 295 | 1252 | 0.1% |
| 294 | 2171 | |
| 293 | 1214 | 0.1% |
| 277 | 1629 | |
| 275 | 3297 |
breadth
Real number (ℝ)
High correlation 
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.291348 |
| Minimum | 8 |
|---|---|
| Maximum | 60 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 13 |
| median | 22 |
| Q3 | 24 |
| 95-th percentile | 27 |
| Maximum | 60 |
| Range | 52 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 6.1613635 |
|---|---|
| Coefficient of variation (CV) | 0.30364486 |
| Kurtosis | 5.1807798 |
| Mean | 20.291348 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.92568828 |
| Sum | 18538074 |
| Variance | 37.9624 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22 | 138472 | |
| 23 | 111574 | |
| 12 | 106192 | |
| 24 | 101595 | |
| 13 | 95877 | |
| 25 | 67310 | |
| 26 | 50019 | 5.5% |
| 18 | 42465 | 4.6% |
| 19 | 38486 | 4.2% |
| 27 | 26464 | 2.9% |
| Other values (24) | 135141 |
| Value | Count | Frequency (%) |
| 8 | 1771 | 0.2% |
| 9 | 637 | 0.1% |
| 10 | 3532 | 0.4% |
| 11 | 24132 | 2.6% |
| 12 | 106192 | |
| 13 | 95877 | |
| 14 | 13278 | 1.5% |
| 15 | 14257 | 1.6% |
| 16 | 12904 | 1.4% |
| 17 | 1662 | 0.2% |
| Value | Count | Frequency (%) |
| 60 | 1716 | 0.2% |
| 59 | 660 | 0.1% |
| 56 | 1153 | 0.1% |
| 48 | 1142 | 0.1% |
| 42 | 1071 | 0.1% |
| 40 | 3919 | 0.4% |
| 36 | 652 | 0.1% |
| 35 | 564 | 0.1% |
| 33 | 681 | 0.1% |
| 32 | 13768 |
draught
Real number (ℝ)
High correlation 
| Distinct | 248 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4860624 |
| Minimum | 0.1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 2.8 |
| Q1 | 4.6 |
| median | 7.2 |
| Q3 | 8.3 |
| 95-th percentile | 9.3 |
| Maximum | 14 |
| Range | 13.9 |
| Interquartile range (IQR) | 3.7 |
Descriptive statistics
| Standard deviation | 2.187501 |
|---|---|
| Coefficient of variation (CV) | 0.33726179 |
| Kurtosis | -1.0358573 |
| Mean | 6.4860624 |
| Median Absolute Deviation (MAD) | 1.6 |
| Skewness | -0.29239943 |
| Sum | 5925634.2 |
| Variance | 4.7851608 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.8 | 46318 | 5.1% |
| 3.2 | 31677 | 3.5% |
| 8.3 | 24085 | 2.6% |
| 7.9 | 17477 | 1.9% |
| 7.7 | 17073 | 1.9% |
| 8.4 | 15522 | 1.7% |
| 8.1 | 15030 | 1.6% |
| 8 | 14613 | 1.6% |
| 3.8 | 14105 | 1.5% |
| 9.2 | 14024 | 1.5% |
| Other values (238) | 703671 |
| Value | Count | Frequency (%) |
| 0.1 | 637 | 0.1% |
| 1.93 | 1771 | 0.2% |
| 2.3 | 1607 | 0.2% |
| 2.4 | 1828 | 0.2% |
| 2.5 | 1373 | 0.2% |
| 2.6 | 7279 | 0.8% |
| 2.63 | 41 | < 0.1% |
| 2.7 | 1782 | 0.2% |
| 2.8 | 46318 | |
| 2.9 | 471 | 0.1% |
| Value | Count | Frequency (%) |
| 14 | 15 | < 0.1% |
| 13.23 | 544 | |
| 11.7 | 645 | |
| 11.54 | 1071 | |
| 11.45 | 551 | |
| 11.4 | 1223 | |
| 11.24 | 691 | |
| 11.1 | 627 | |
| 11 | 368 | < 0.1% |
| 10.98 | 211 | < 0.1% |
latitude
Real number (ℝ)
High correlation 
| Distinct | 273 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.287471 |
| Minimum | 53.33 |
|---|---|
| Maximum | 56.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 53.33 |
|---|---|
| 5-th percentile | 53.56 |
| Q1 | 53.85 |
| median | 54.47 |
| Q3 | 54.65 |
| 95-th percentile | 54.89 |
| Maximum | 56.34 |
| Range | 3.01 |
| Interquartile range (IQR) | 0.8 |
Descriptive statistics
| Standard deviation | 0.45826776 |
|---|---|
| Coefficient of variation (CV) | 0.0084415014 |
| Kurtosis | -1.0504964 |
| Mean | 54.287471 |
| Median Absolute Deviation (MAD) | 0.34 |
| Skewness | -0.13312877 |
| Sum | 49596762 |
| Variance | 0.21000934 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 53.87 | 28797 | 3.2% |
| 54.53 | 23462 | 2.6% |
| 54.41 | 20333 | 2.2% |
| 53.84 | 20044 | 2.2% |
| 53.98 | 19631 | 2.1% |
| 54.56 | 17212 | 1.9% |
| 53.54 | 17009 | 1.9% |
| 53.86 | 16700 | 1.8% |
| 54.74 | 16683 | 1.8% |
| 54.57 | 16667 | 1.8% |
| Other values (263) | 717057 |
| Value | Count | Frequency (%) |
| 53.33 | 13 | < 0.1% |
| 53.34 | 40 | |
| 53.35 | 29 | |
| 53.36 | 26 | |
| 53.37 | 25 | |
| 53.38 | 27 | |
| 53.39 | 26 | |
| 53.4 | 23 | |
| 53.41 | 24 | |
| 53.42 | 26 |
| Value | Count | Frequency (%) |
| 56.34 | 2 | < 0.1% |
| 56.33 | 4 | < 0.1% |
| 56.32 | 4 | < 0.1% |
| 56.31 | 3 | < 0.1% |
| 56.3 | 3 | < 0.1% |
| 56.29 | 12 | |
| 56.28 | 8 | |
| 56.27 | 5 | |
| 56.26 | 5 | |
| 56.25 | 6 |
longitude
Real number (ℝ)
High correlation 
| Distinct | 1285 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.995706 |
| Minimum | 2.32 |
|---|---|
| Maximum | 20.66 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 2.32 |
|---|---|
| 5-th percentile | 8.08 |
| Q1 | 9.03 |
| median | 11.08 |
| Q3 | 14.12 |
| 95-th percentile | 18.8 |
| Maximum | 20.66 |
| Range | 18.34 |
| Interquartile range (IQR) | 5.09 |
Descriptive statistics
| Standard deviation | 3.5082389 |
|---|---|
| Coefficient of variation (CV) | 0.29245789 |
| Kurtosis | -0.65372502 |
| Mean | 11.995706 |
| Median Absolute Deviation (MAD) | 2.4 |
| Skewness | 0.74749541 |
| Sum | 10959217 |
| Variance | 12.30774 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.51 | 4757 | 0.5% |
| 8.52 | 4514 | 0.5% |
| 8.12 | 4441 | 0.5% |
| 9.93 | 4405 | 0.5% |
| 8.11 | 4178 | 0.5% |
| 9.9 | 4113 | 0.5% |
| 9.5 | 4022 | 0.4% |
| 8.51 | 3619 | 0.4% |
| 8.15 | 3189 | 0.3% |
| 9.39 | 3178 | 0.3% |
| Other values (1275) | 873179 |
| Value | Count | Frequency (%) |
| 2.32 | 1 | < 0.1% |
| 7.71 | 2 | < 0.1% |
| 7.72 | 45 | |
| 7.73 | 102 | |
| 7.74 | 99 | |
| 7.75 | 108 | |
| 7.76 | 83 | |
| 7.77 | 83 | |
| 7.78 | 81 | |
| 7.79 | 78 |
| Value | Count | Frequency (%) |
| 20.66 | 1 | < 0.1% |
| 20.65 | 3 | |
| 20.64 | 2 | |
| 20.63 | 2 | |
| 20.62 | 3 | |
| 20.61 | 3 | |
| 20.6 | 2 | |
| 20.59 | 3 | |
| 20.58 | 3 | |
| 20.57 | 3 |
speed_over_ground
Real number (ℝ)
| Distinct | 225 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.044391 |
| Minimum | 0.2 |
|---|---|
| Maximum | 22.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 6.5 |
| Q1 | 9.8 |
| median | 11.9 |
| Q3 | 14.6 |
| 95-th percentile | 17.5 |
| Maximum | 22.6 |
| Range | 22.4 |
| Interquartile range (IQR) | 4.8 |
Descriptive statistics
| Standard deviation | 3.5389761 |
|---|---|
| Coefficient of variation (CV) | 0.29382773 |
| Kurtosis | 0.58274964 |
| Mean | 12.044391 |
| Median Absolute Deviation (MAD) | 2.4 |
| Skewness | -0.42493849 |
| Sum | 11003696 |
| Variance | 12.524352 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.4 | 13193 | 1.4% |
| 10.5 | 13133 | 1.4% |
| 10.7 | 12783 | 1.4% |
| 10.6 | 12764 | 1.4% |
| 10.3 | 12519 | 1.4% |
| 11 | 11598 | 1.3% |
| 11.6 | 11505 | 1.3% |
| 10.9 | 11485 | 1.3% |
| 10.2 | 11480 | 1.3% |
| 11.7 | 11383 | 1.2% |
| Other values (215) | 791752 |
| Value | Count | Frequency (%) |
| 0.2 | 442 | < 0.1% |
| 0.3 | 1617 | |
| 0.4 | 1337 | |
| 0.5 | 1054 | |
| 0.6 | 958 | |
| 0.7 | 814 | |
| 0.8 | 907 | |
| 0.9 | 843 | |
| 1 | 771 | |
| 1.1 | 738 |
| Value | Count | Frequency (%) |
| 22.6 | 1 | < 0.1% |
| 22.5 | 1 | < 0.1% |
| 22.4 | 2 | < 0.1% |
| 22.3 | 1 | < 0.1% |
| 22.2 | 4 | < 0.1% |
| 22.1 | 4 | < 0.1% |
| 22 | 6 | |
| 21.9 | 5 | |
| 21.8 | 6 | |
| 21.7 | 12 |
course_over_ground
Real number (ℝ)
High correlation 
| Distinct | 3601 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 124.97899 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 192 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 44 |
| Q1 | 81.8 |
| median | 99.1 |
| Q3 | 134 |
| 95-th percentile | 312 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 52.2 |
Descriptive statistics
| Standard deviation | 76.465793 |
|---|---|
| Coefficient of variation (CV) | 0.61182916 |
| Kurtosis | 1.3315164 |
| Mean | 124.97899 |
| Median Absolute Deviation (MAD) | 21.5 |
| Skewness | 1.493163 |
| Sum | 1.1418018 × 108 |
| Variance | 5847.0174 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 81 | 7475 | 0.8% |
| 90 | 7334 | 0.8% |
| 82 | 6782 | 0.7% |
| 86 | 5624 | 0.6% |
| 89 | 5526 | 0.6% |
| 85 | 5337 | 0.6% |
| 83 | 5150 | 0.6% |
| 87 | 4993 | 0.5% |
| 88 | 4950 | 0.5% |
| 100 | 4679 | 0.5% |
| Other values (3591) | 855745 |
| Value | Count | Frequency (%) |
| 0 | 192 | |
| 0.1 | 290 | |
| 0.2 | 26 | < 0.1% |
| 0.3 | 26 | < 0.1% |
| 0.4 | 19 | < 0.1% |
| 0.5 | 37 | < 0.1% |
| 0.6 | 31 | < 0.1% |
| 0.7 | 29 | < 0.1% |
| 0.8 | 23 | < 0.1% |
| 0.9 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 360 | 12 | < 0.1% |
| 359.9 | 43 | |
| 359.8 | 29 | |
| 359.7 | 16 | < 0.1% |
| 359.6 | 28 | |
| 359.5 | 28 | |
| 359.4 | 20 | |
| 359.3 | 31 | |
| 359.2 | 22 | |
| 359.1 | 40 |
true_heading
Real number (ℝ)
High correlation 
| Distinct | 361 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 130.71852 |
| Minimum | 0 |
|---|---|
| Maximum | 511 |
| Zeros | 565 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 82 |
| median | 99 |
| Q3 | 136 |
| 95-th percentile | 320 |
| Maximum | 511 |
| Range | 511 |
| Interquartile range (IQR) | 54 |
Descriptive statistics
| Standard deviation | 89.243751 |
|---|---|
| Coefficient of variation (CV) | 0.68271695 |
| Kurtosis | 3.8355445 |
| Mean | 130.71852 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 1.9151708 |
| Sum | 1.1942379 × 108 |
| Variance | 7964.4471 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 82 | 22874 | 2.5% |
| 81 | 21301 | 2.3% |
| 83 | 20883 | 2.3% |
| 90 | 20022 | 2.2% |
| 84 | 18941 | 2.1% |
| 85 | 18885 | 2.1% |
| 89 | 16462 | 1.8% |
| 86 | 16055 | 1.8% |
| 88 | 15375 | 1.7% |
| 80 | 15244 | 1.7% |
| Other values (351) | 727553 |
| Value | Count | Frequency (%) |
| 0 | 565 | |
| 1 | 410 | |
| 2 | 349 | |
| 3 | 363 | |
| 4 | 262 | |
| 5 | 277 | |
| 6 | 271 | |
| 7 | 314 | |
| 8 | 282 | |
| 9 | 205 | < 0.1% |
| Value | Count | Frequency (%) |
| 511 | 12963 | |
| 359 | 399 | < 0.1% |
| 358 | 412 | < 0.1% |
| 357 | 337 | < 0.1% |
| 356 | 395 | < 0.1% |
| 355 | 465 | 0.1% |
| 354 | 408 | < 0.1% |
| 353 | 295 | < 0.1% |
| 352 | 265 | < 0.1% |
| 351 | 223 | < 0.1% |
destination
Categorical
High correlation  Imbalance 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 68 |
| Missing (%) | < 0.1% |
| Memory size | 54.9 MiB |
| DE.HAM | |
|---|---|
| PL.GDY | |
| PL.GDN | |
| LT.KLJ | 23353 |
| DE.STA | 3787 |
| Other values (11) | 8147 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DE.HAM |
|---|---|
| 2nd row | DE.HAM |
| 3rd row | DE.HAM |
| 4th row | DE.HAM |
| 5th row | DE.HAM |
Common Values
| Value | Count | Frequency (%) |
| DE.HAM | 375027 | |
| PL.GDY | 291375 | |
| PL.GDN | 211838 | |
| LT.KLJ | 23353 | 2.6% |
| DE.STA | 3787 | 0.4% |
| DE.KEL | 3267 | 0.4% |
| DE.BRV | 2439 | 0.3% |
| RU.KGD | 1337 | 0.1% |
| SE.NOK | 540 | 0.1% |
| SE.HAD | 334 | < 0.1% |
| Other values (6) | 230 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| de.ham | 375027 | |
| pl.gdy | 291375 | |
| pl.gdn | 211838 | |
| lt.klj | 23353 | 2.6% |
| de.sta | 3787 | 0.4% |
| de.kel | 3267 | 0.4% |
| de.brv | 2439 | 0.3% |
| ru.kgd | 1337 | 0.1% |
| se.nok | 540 | 0.1% |
| se.had | 334 | < 0.1% |
| Other values (6) | 230 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 913527 | |
| D | 889526 | |
| L | 553292 | |
| G | 504550 | |
| P | 503319 | |
| E | 388827 | |
| A | 379148 | |
| H | 375363 | |
| M | 375027 | |
| Y | 291375 | 5.3% |
| Other values (13) | 307208 | 5.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5481162 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 913527 | |
| D | 889526 | |
| L | 553292 | |
| G | 504550 | |
| P | 503319 | |
| E | 388827 | |
| A | 379148 | |
| H | 375363 | |
| M | 375027 | |
| Y | 291375 | 5.3% |
| Other values (13) | 307208 | 5.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5481162 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 913527 | |
| D | 889526 | |
| L | 553292 | |
| G | 504550 | |
| P | 503319 | |
| E | 388827 | |
| A | 379148 | |
| H | 375363 | |
| M | 375027 | |
| Y | 291375 | 5.3% |
| Other values (13) | 307208 | 5.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5481162 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 913527 | |
| D | 889526 | |
| L | 553292 | |
| G | 504550 | |
| P | 503319 | |
| E | 388827 | |
| A | 379148 | |
| H | 375363 | |
| M | 375027 | |
| Y | 291375 | 5.3% |
| Other values (13) | 307208 | 5.6% |
Interactions
Correlations
| breadth | course_over_ground | destination | draught | end_latitude | end_longitude | end_port | latitude | length | longitude | ship_type | speed_over_ground | start_latitude | start_longitude | start_port | trip_id | true_heading | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| breadth | 1.000 | 0.034 | 0.197 | 0.902 | 0.078 | -0.272 | 0.406 | -0.088 | 0.937 | -0.097 | 0.302 | 0.432 | -0.037 | -0.183 | 0.406 | -0.020 | 0.020 |
| course_over_ground | 0.034 | 1.000 | 0.167 | 0.004 | -0.290 | -0.290 | 0.460 | -0.344 | -0.005 | -0.123 | 0.036 | 0.001 | -0.323 | -0.307 | 0.460 | 0.007 | 0.937 |
| destination | 0.197 | 0.167 | 1.000 | 0.182 | 0.698 | 0.995 | 0.995 | 0.354 | 0.230 | 0.327 | 0.170 | 0.136 | 0.448 | 0.704 | 0.995 | 0.160 | 0.155 |
| draught | 0.902 | 0.004 | 0.182 | 1.000 | 0.120 | -0.179 | 0.266 | -0.019 | 0.913 | -0.028 | 0.330 | 0.424 | 0.067 | -0.106 | 0.266 | 0.018 | -0.003 |
| end_latitude | 0.078 | -0.290 | 0.698 | 0.120 | 1.000 | 0.525 | 1.000 | 0.751 | 0.152 | 0.736 | -0.096 | -0.020 | 0.815 | 0.798 | 1.000 | -0.025 | -0.283 |
| end_longitude | -0.272 | -0.290 | 0.995 | -0.179 | 0.525 | 1.000 | 1.000 | 0.719 | -0.156 | 0.731 | -0.037 | -0.268 | 0.813 | 0.817 | 1.000 | 0.009 | -0.262 |
| end_port | 0.406 | 0.460 | 0.995 | 0.266 | 1.000 | 1.000 | 1.000 | 1.000 | 0.398 | 0.919 | 0.229 | 0.246 | 1.000 | 1.000 | 1.000 | 0.263 | 0.397 |
| latitude | -0.088 | -0.344 | 0.354 | -0.019 | 0.751 | 0.719 | 1.000 | 1.000 | 0.006 | 0.800 | -0.071 | -0.043 | 0.813 | 0.797 | 1.000 | -0.013 | -0.322 |
| length | 0.937 | -0.005 | 0.230 | 0.913 | 0.152 | -0.156 | 0.398 | 0.006 | 1.000 | -0.001 | 0.274 | 0.427 | 0.099 | -0.100 | 0.398 | -0.049 | -0.015 |
| longitude | -0.097 | -0.123 | 0.327 | -0.028 | 0.736 | 0.731 | 0.919 | 0.800 | -0.001 | 1.000 | -0.075 | -0.211 | 0.814 | 0.798 | 0.919 | -0.013 | -0.111 |
| ship_type | 0.302 | 0.036 | 0.170 | 0.330 | -0.096 | -0.037 | 0.229 | -0.071 | 0.274 | -0.075 | 1.000 | 0.189 | -0.069 | -0.088 | 0.229 | 0.146 | 0.036 |
| speed_over_ground | 0.432 | 0.001 | 0.136 | 0.424 | -0.020 | -0.268 | 0.246 | -0.043 | 0.427 | -0.211 | 0.189 | 1.000 | -0.113 | -0.191 | 0.246 | -0.058 | -0.025 |
| start_latitude | -0.037 | -0.323 | 0.448 | 0.067 | 0.815 | 0.813 | 1.000 | 0.813 | 0.099 | 0.814 | -0.069 | -0.113 | 1.000 | 0.842 | 1.000 | -0.012 | -0.304 |
| start_longitude | -0.183 | -0.307 | 0.704 | -0.106 | 0.798 | 0.817 | 1.000 | 0.797 | -0.100 | 0.798 | -0.088 | -0.191 | 0.842 | 1.000 | 1.000 | -0.004 | -0.286 |
| start_port | 0.406 | 0.460 | 0.995 | 0.266 | 1.000 | 1.000 | 1.000 | 1.000 | 0.398 | 0.919 | 0.229 | 0.246 | 1.000 | 1.000 | 1.000 | 0.263 | 0.397 |
| trip_id | -0.020 | 0.007 | 0.160 | 0.018 | -0.025 | 0.009 | 0.263 | -0.013 | -0.049 | -0.013 | 0.146 | -0.058 | -0.012 | -0.004 | 0.263 | 1.000 | 0.007 |
| true_heading | 0.020 | 0.937 | 0.155 | -0.003 | -0.283 | -0.262 | 0.397 | -0.322 | -0.015 | -0.111 | 0.036 | -0.025 | -0.304 | -0.286 | 0.397 | 0.007 | 1.000 |
Missing values
Sample
| trip_id | start_latitude | start_longitude | start_time | end_latitude | end_longitude | end_time | start_port | end_port | time_stamp | ship_type | length | breadth | draught | latitude | longitude | speed_over_ground | course_over_ground | true_heading | destination | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:07:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 0.7 | 331.2 | 143 | DE.HAM |
| 1 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:10:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 1.6 | 315.3 | 117 | DE.HAM |
| 2 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:10:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 2.8 | 322.6 | 100 | DE.HAM |
| 3 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:12:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 2.8 | 286.3 | 74 | DE.HAM |
| 4 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:16:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 4.3 | 333.1 | 333 | DE.HAM |
| 5 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:17:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 5.2 | 334.0 | 333 | DE.HAM |
| 6 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:18:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.53 | 5.7 | 333.0 | 333 | DE.HAM |
| 7 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:19:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.57 | 8.52 | 6.3 | 333.0 | 333 | DE.HAM |
| 8 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:20:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.58 | 8.52 | 6.8 | 333.0 | 333 | DE.HAM |
| 9 | 39131 | 53.57 | 8.53 | 2016-01-24 08:06:00+00:00 | 53.53 | 9.9 | 2016-01-24 16:44:00+00:00 | BREMERHAVEN | HAMBURG | 2016-01-24 08:21:00+00:00 | 71.0 | 277.0 | 42.0 | 11.54 | 53.58 | 8.52 | 7.1 | 332.1 | 333 | DE.HAM |
| trip_id | start_latitude | start_longitude | start_time | end_latitude | end_longitude | end_time | start_port | end_port | time_stamp | ship_type | length | breadth | draught | latitude | longitude | speed_over_ground | course_over_ground | true_heading | destination | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 913585 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 14:02:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.50 | 18.74 | 7.2 | 222.0 | 215 | PL.GDN |
| 913586 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 14:01:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.50 | 18.74 | 7.2 | 221.6 | 215 | PL.GDN |
| 913587 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 14:00:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.50 | 18.74 | 7.2 | 221.5 | 215 | PL.GDN |
| 913588 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:59:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.50 | 18.75 | 7.2 | 221.2 | 215 | PL.GDN |
| 913589 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:58:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.50 | 18.75 | 7.2 | 220.8 | 215 | PL.GDN |
| 913590 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:57:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.51 | 18.75 | 7.2 | 221.0 | 215 | PL.GDN |
| 913591 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:56:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.51 | 18.75 | 7.2 | 221.9 | 215 | PL.GDN |
| 913592 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:55:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.51 | 18.75 | 7.2 | 222.1 | 215 | PL.GDN |
| 913593 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:54:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.51 | 18.76 | 7.2 | 221.2 | 215 | PL.GDN |
| 913594 | 2204049 | 54.36 | 10.14 | 2017-04-03 07:54:00+00:00 | 54.38 | 18.66 | 2017-04-04 15:28:00+00:00 | KIEL | GDYNIA | 2017-04-04 13:53:00+00:00 | 70.0 | 89.0 | 13.0 | 4.0 | 54.51 | 18.76 | 7.2 | 221.0 | 214 | PL.GDN |